SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




ALTER     VIEW dbo.v_td_depottype
AS
SELECT dt.*, k.kname,s.subname
FROM dbo.td_depottype dt 
  LEFT OUTER JOIN dbo.ts_kind k ON dt.ioflag = k.kid
  Left outer join dbo.tfd_subject s on dt.subid=s.subjectid
WHERE (k.kind = 5105)




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

